using System;
using System.Data;
using System.Data.SqlClient;

namespace FAS.DataBase
{
    public interface IDbController
    {
        bool OpenConnection();
        bool CloseConnection();
        bool BeginTransaction();
        bool CommitTransaction();
        bool RollbackTransaction();

        DataSet Select(string strSqlStatement);
        DataSet Select(string strSqlStatement, SqlParameter[] objParas);
        int Execute(string strSqlStatement);
        int Execute(string strSqlStatement, SqlParameter[] objParas);
        DataSet SpSelect(string strSqlStatement);
        DataSet SpSelect(string strSqlStatement, SqlParameter[] objParas);
        void SpExecute(string strSpName);
        void SpExecute(string strSpName, SqlParameter[] objParas);
    }
}
